<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>q
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: lenovo
  Date: 2018/3/19
  Time: 21:04
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>


  <%--<h1>这是一个JSP文件</h1>--%>
  <%--<%--%>
    <%--out.write("hello,world!");--%>

    <%--out.write("<h1>hello,world!</h1>");--%>
  <%--%>--%>
  <%
    //判断是否登陆
    if (session.getAttribute("isLogin")==null){
        //没有登陆，跳转Login.jsp
      response.sendRedirect("login.jsp");
    }
  %>
  <style type="text/css">
    table{
      border: 1px solid #000;
      border-collapse: collapse;
    }
    td,th{
      border: 1px solid #000;
      padding: 10px;
    }
  </style>
  <p><a href="userAdd.jsp">添加用户</a></p><br/>
  <p><a href="userupdate.jsp">更新数据</a></p><br/>
  <p><a href="userDelect.jsp">删除用户</a></p><br/>
  <table>
  <thead>
  <tr>
    <td>编号</td>
    <td>名字</td>
    <td>密码</td>
      <td>更新</td>
      <td>删除</td>
  </tr>
  </thead>
  <tbody>
  <%
//    boolean isLogin=false;
//    if (isLogin==false){
//
//    }
    class User{
        int id;
        String name;
        String password;
        //alr+insert

      public User(int id, String name, String password) {
        this.id = id;
        this.name = name;
        this.password = password;
      }
    }
//    User chen=new User(1,"cheng","123456");
//    chen.id=1;
//    chen.name="cheng";
//    chen.password="123456";
    List<User> list=new ArrayList<>();
//    list.add(new User(1,"fcl","12456"));
//    list.add(new User(2,"zxm","68900"));
//    list.add(new User(3,"wer","68797"));
//    list.add(new User(4,"wang","468278"));

    Connection connection=null;
    Statement statement=null;
    ResultSet resultSet=null;
    String sql="select*from t_users";
    Class.forName("com.mysql.jdbc.Driver");
    connection= DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
            "root",
            "123456"
    );
    statement=connection.createStatement();
    resultSet=statement.executeQuery(sql);
    while (resultSet.next()){

        int id=resultSet.getInt(1);
        String username=resultSet.getString(2);
        String password=resultSet.getString(3);

        User user=new User(id,username,password);
        list.add(user);
    }
    resultSet.close();
    statement.close();
    connection.close();

    for (User user:list){
        out.write("<tr><td>"+user.id+"</td><td>"+user.name
                +"</td><td>"+user.password+"</td>" +
                "<td><a href='userupdate.jsp?id=" + user.id + "&name="+user.name+"&password="+user.password+"'>更新" +
                "</a></td><td><a href='userDelete.jsp?id="
                      + user.id + "'>删除</a></td></tr>");
    }
//    for (int i = 0; i <10; i++) {
//      //alt+shilft+向上的方向键
//      //ctrl+alt+l个是代码
//      out.write("<td></td>"+"<td>Jhon</td><td>12345</td>");
//    }

  %>
  <%--<tr>--%>
    <%--<td>1</td>--%>
    <%--<td>Jhon</td>--%>
    <%--<td>12345</td>--%>
  <%--</tr>--%>
  <%--<tr>--%>
    <%--<td>2</td>--%>
    <%--<td>Tom</td>--%>
    <%--<td>12345</td>--%>
  <%--</tr>--%>
  </tbody>
  </table>
  </body>
</html>
